Datetime in humane format

Поиск
Список
Период
Сортировка
От lynch@lscorp.com (Richard Lynch)
Тема Datetime in humane format
Дата
Msg-id v02140b15b2177863c44f@[207.152.64.133]
обсуждение исходный текст
Ответы Re: [SQL] Datetime in humane format  (Herouth Maoz <herouth@oumail.openu.ac.il>)
Re: [SQL] Datetime in humane format  (Eric McKeown <ericm@palaver.net>)
Список pgsql-sql
So, I followed the advice in the archives and used the datetime type.

Now, I've got entries like 'Sun Sep 06 00:06:57 1998 EDT' in my table.

So, how do I turn that into something that a normal human can read?

"Sep 06 1998 12:06 am" would be nice...

Or, how do I turn that back into seconds since epoch?  I'm using PHP which
has a nice date function that I think I can coerce into giving me what I
want... unless it also thinks that humans understand 00:06:57 as just after
midnight...

--
--
-- "TANSTAAFL" Rich lynch@lscorp.com



В списке pgsql-sql по дате отправления:

Предыдущее
От: Andrew M Tracey
Дата:
Сообщение: constraints don't work...
Следующее
От: Herouth Maoz
Дата:
Сообщение: Re: [SQL] Datetime in humane format